Previous Topic

Next Topic

To format data for import

The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records. There should not be any empty lines between record entries.

Note: You can use the AR Importer for accrual dues billing.

The major transaction formats include the following:

All records

#

Field Name

Data

Comments

1

Record Type

 

Identifies the type of record

2

Batch Number

10 chars, all upper case

 

Batch header

#

Field Name

Data

Comments

1

Record Type

BH

Always "BH"

2

Batch Number

10 chars, all upper case

 

3

Batch Date

Date

Date of batch (mm/dd/yy)

4

Batch Description

60 chars

 

5

Control Count

Numeric

Optional

6

Control Amount

Monetary

Total of the batch of payments

7

Cash Account Code

10 chars, all upper case

Code assigned through the Set up cash accounts window. Indicates the cash account into which the funds were deposited.

Cash payment record

#

Field Name

Data

Comments

1

Record Type

PAY

Always "PAY"

2

Batch Number

10 chars, all upper case

Optional. If blank, defaults to batch header's batch number.

3

System

AR

 

4

Customer ID

10 chars, customer ID

Can substitute with Major Key, if prefixed with * (asterisk)

5

Date

Date

Optional. If blank, defaults to batch header date.

6

Invoice

Alphanumeric

The invoice number. This field is required if the Auto Apply option is not enabled in the AR/Cash Set up module window.

7

Amount

Individual payment amount

Total amount of the check or credit card payment. Do not enter a $ (dollar sign).

8

Check/CCType

Check number or credit card type

Optional

9

CCNumber

Credit card number

Optional

10

CCExp

Credit card expiriation date

Optional

11

Name on CC

Name on credit card

Optional

12

CCAuthorize

Credit card authorization code

Optional

13

Name

60 chars for audit trail

Optional but important. This value is printed on the transaction report to identify the customer.

14

Comment

255 chars

Optional but important. This value is printed on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment".

See Also

Using iMIS AR Importer

To enable the iMIS AR Importer module

Example Import File

To review history before importing transactions

To perform the import

To verify the import

To view open credits from an import


ASI logo 10.6 Production Release. Updated 10/5/2005 3:10:20 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.